﻿using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.Sql;
 
namespace sgsBase
{
	[Serializable] public class DbUsrPasswordReset :  DbObject
	{
	  public DbUsrPasswordReset() : base()
	  {
		  Table = "dbo.usr_password_reset";
		  Database = "sgs_core";
		  Columns.AddColumn("user_id", SqlDbType.Int, true, false);
		  Columns.AddColumn("dt_request", SqlDbType.DateTime, true, false);
		  Columns.AddColumn("hash_code", SqlDbType.VarChar);
		  Columns.AddColumn("dt_completed", SqlDbType.DateTime);
		  Columns.AddColumn("ip_address", SqlDbType.VarChar);
	  }
  
	  #region Properties
  
		  public int UserId
		  {
			  get { return Columns.IntAt(0);}
			  set { Columns.SetValAt(0, value);}
		  }

		  public DateTime DtRequest
		  {
			  get { return Columns.DateTimeTSAt(1);}
			  set { Columns.SetValAt(1, value, true);}
		  }

		  public String HashCode
		  {
			  get { return Columns.StringAt(2);}
			  set { Columns.SetValAt(2, value);}
		  }

		  public DateTime DtCompleted
		  {
			  get { return Columns.DateTimeTSAt(3);}
			  set { Columns.SetValAt(3, value, true);}
		  }

		  public String IpAddress
		  {
			  get { return Columns.StringAt(4);}
			  set { Columns.SetValAt(4, value);}
		  }

  
	  #endregion
	}
}
